Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | |
ActivityCode | Activity code defines actions that may be applied to a SVI that changes its state and the monetary balance it carries. Valid values (based on POSLOG6) include: Activation enables a stored value -instrument Associate BalanceTransfer transfer balance from one SVI to another Cancel Cancel a Card ( Cashout Convert balance to cash and deactivate Deactivate Deactivate a card Expired SVI expired - escheatment Recharge Add monetary value to the SVI Refund Refund value (add prior Replace Replace the SVI Stolen Flag SVI as stolen and deactivate it Void Flag SVI as VOID and deactivate it | CD_ACTV | Code | varchar(20) | |
StoredValueInstrumentID (FK) | A token ID for a StoredValueInstrument | ID_STRD_VL_INSTRMNT | Identity | integer | StoredValueInstrument(DO_STRD_VL_INSTRMNT) |
CustomerAccountID (FK) | A unique identifier for a customer account. | ID_CTAC | Identity | integer | CustomerStoredValueAccount(LE_CT_STRD_VL_ACNT) |